MatchedCols Function

Syntax

the matchedCols of <dataSheet>

where "condition" Applies to datasheets

Description

The matchedCols function is a query function that returns a comma-delimited list of numbers that correspond to the columns of a dataSheet that satisfy the given constraints. The constraints are specified using a string expression. You can use several constraints joined by logical operators. Each constraint must use the following format: [not] <row> [= | > | < | etc.] value

Examples

You can use the matchedCols function to find matching data with spaces in it. For example, into selectedColVar Row 2 will be searched for values that are greater than Smith and row 5 will be searched for values greater than 32000. The resulting string of matching column numbers will be put into the variable selectedColVar.